Abstract: For solving the problems that the special investigation software with the complicated operation, bad elasticity, bad adaptability, sometime not enough capacity, lower handwork operation efficiency and easy to make mistake when conducting “copy” and “paste”, can not meet the requirement of fast production when carrying out to plot the “location of exploratory point” by category of exploratory point during the large geological investigation process, this paper develops the fast plotting exploratory point technology by category in CAD with Excel form, combines the strong data calculation and process functions of Excel and the strong plotting functions of CAD, omits the form and transfer sector of “SCR script document”, it is of the simple method, easy to operate, good elasticity, strong adaptability, conduct adjusting and revising in batches conveniently, large data capacity, and can plot more than 10000 exploratory points once time. It can be used repeatedly after forming formwork, is of certain usage value in large engineering.

Key words: Excel, macro, CAD, investigation, exploratory points, by category, fast plotting